---
title: "SAIF.Business.View.Policy stored procedures"
summary: "Catalog of database procedures, packages, and functions referenced by SAIF.Business.View.Policy."
status: draft
owner: "SAIF Corporation"
last_reviewed: 2026-08-31
library: SAIF.Business.View.Policy
reference_type: embedded
---

# SAIF.Business.View.Policy stored procedures

This page catalogs database procedures, packages, and functions invoked by this library.

> [!IMPORTANT]
> **13 `found` / 1 `unresolvable-dynamic-name` / 0 `not-found`.** All 13 concrete procedure/package
> targets were successfully retrieved via the Legends CLI — 8 Oracle objects (schema `WCIS_DBA`) and
> 5 SQL Server BDS objects (`eisD0P11.dbo`) — and each has at least one live .NET call site in
> `SAIF.Business.View.Policy`. The 14th catalog entry, `ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME`,
> is not a procedure name at all — it is a reference-data **column** whose value supplies a procedure
> name at runtime, so static retrieval is impossible by construction. None of the 14 entries is
> missing, orphaned, or dead code.

## Procedure catalog

| Package / Procedure | Schema | Type | Status | Purpose | Calling business objects |
| --- | --- | --- | --- | --- | --- |
| [`pk72846_view_policy`](pk72846-view-policy.md) | `WCIS_DBA` | Oracle package (34 members) | `found` | Affiliated policy, agency, address, detail, parent-policy, gaps, period, and team-assignment retrieval for policy view objects | `clsPolicyData`, `clsPolicyPeriodCollection`, `clsAgency`, `clsPolicyAddress`, `clsAffiliatedPolicyCollection`, `clsTeamAssignmentCollection`, `clsMCOCollection`, `clsPolicyMCOCollection` |
| [`pk73094_policy_data`](pk73094-policy-data.md) | `WCIS_DBA` | Oracle package | `found` | Primary policy-header retrieval, including derived cancel status, for policy view data objects | `clsPolicyData` |
| [`Pk82033_ThirdParty`](pk82033-thirdparty.md) | `WCIS_DBA` | Oracle package (92 members; 1 invoked) | `found` | Third-party waiver-count lookup for policy records | `clsPolicyData` |
| [`coveragelimits_pkg`](coveragelimits-pkg.md) | `WCIS_DBA` | Oracle package (5 members; 1 invoked) | `found` | Employer liability coverage-limit retrieval for a policy period | `clsPolicyPeriod` |
| [`sp72268_get_cancel_status`](sp72268-get-cancel-status.md) | `WCIS_DBA` | Oracle function | `found` | Derives a display cancel status for a policy from status group, demand, audit, and legal-action state | `clsPolicyData` |
| [`sp73089_get_policy_bound_flag`](sp73089-get-policy-bound-flag.md) | `WCIS_DBA` | Oracle function | `found` | Coverage-bound flag lookup for a policy period, delegated to the shared bound-check procedure | `clsPolicyData` |
| [`SP72347_INFO_PAGE_PRINTED_YN`](sp72347-info-page-printed-yn.md) | `WCIS_DBA` | Oracle function | `found` | Information-page-printed flag lookup for a policy period, delegated to the shared info-page-printed procedure | `clsPolicyData` |
| [`sp73341_external_client_lookup`](sp73341-external-client-lookup.md) | `WCIS_DBA` | Oracle function | `found` | External client email lookup for team-assignment contacts, sourced from `system_user_contractor` | `clsTeamAssignment` |
| [`cp_policy_in_group`](cp-policy-in-group.md) | `eisD0P11.dbo` | SQL Server stored procedure (BDS) | `found` | Group/chapter membership validation for policy-security checks | `clsPolicySecurity` |
| [`cp_claimprofile_get_group_policy_list`](cp-claimprofile-get-group-policy-list.md) | `eisD0P11.dbo` | SQL Server stored procedure (BDS) | `found` | Group/chapter policy-list retrieval for policy-security filtering, as of a report date | `clsPolicySecurity` |
| [`cp_claimprofile_get_sc_book`](cp-claimprofile-get-sc-book.md) | `eisD0P11.dbo` | SQL Server stored procedure (BDS) | `found` | Safety-consultant policy-book retrieval | `clsPolicySecurity` |
| [`cp_get_agent_online_policy_list`](cp-get-agent-online-policy-list.md) | `eisD0P11.dbo` | SQL Server stored procedure (BDS) | `found` | Agent or agency online policy-list retrieval, active and recently closed | `clsPolicySecurity` |
| [`cp_external_client_lookup`](cp-external-client-lookup.md) | `eisD0P11.dbo` | SQL Server stored procedure (BDS) | `found` | External client email-address lookup for non-SAIF team members | `clsTeamAssignment` |
| [`ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME`](association-type-code-source-procedure-name.md) | n/a (name supplied by data) | Runtime-resolved procedure name | `unresolvable-dynamic-name` | Executes whichever procedure name is stored in the `ASSOCIATION_TYPE_CODE` reference-data column, to return association rows for a policy | `clsAssociationTypeCode` |

### Special case: pk72846_view_policy member — getmco

> [!NOTE]
> **getmco member not present in retrieved source.** The `pk72846_view_policy` package is `found` and successfully retrieved via Legends CLI. However, the specific member `getmco` could not be located in the retrieved package source despite a case-insensitive search of the full artifact. This does not change the package's `found` status: both `clsMCOCollection.vb:231` and `clsPolicyMCOCollection.vb:231` contain live, reachable call sites to this member and are not dead code. No signature, parameters, or behavior are documented for `getmco` beyond this caveat and the two caller citations.

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Configuration](../configuration.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](../sql/index.md)
- [Security and authorization](../security-authorization.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb`
- `SAIF.Business.View.Policy/clsAffiliatedPolicyCollection.vb`
- `SAIF.Business.View.Policy/clsAgency.vb`
- `SAIF.Business.View.Policy/clsPolicyAddress.vb`
- `SAIF.Business.View.Policy/clsPolicyData.vb`
- `SAIF.Business.View.Policy/clsPolicyPeriod.vb`
- `SAIF.Business.View.Policy/clsPolicyPeriodCollection.vb`
- `SAIF.Business.View.Policy/clsPolicySecurity.vb`
- `SAIF.Business.View.Policy/clsTeamAssignment.vb`
- `SAIF.Business.View.Policy/clsTeamAssignmentCollection.vb`
- `SAIF.Business.View.Policy/clsMCOCollection.vb`
- `SAIF.Business.View.Policy/clsPolicyMCOCollection.vb`